package com.qunchuang.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.qunchuang.pojo.entity.LiftStorageLocationEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

//储位表
@Mapper
public interface LiftStorageLocationMapper extends BaseMapper<LiftStorageLocationEntity> {
    @Select("select count(*) from lift_storage_location_table where lift_id =#{liftId} and storage_state =#{storageState}")
    Integer selectLiftStorageCount(String liftId,Integer storageState);
//   @Select("select * from lift_storage_location_table where storage_location_id =#{storageLocationId} and lift_id =#{liftId} and storage_state =#{storageState} and agv_id =#{agvId}")
    LiftStorageLocationEntity selectLiftStorage(String liftId,Integer storageState);
}
